UPDATE personnel
 SET review = (SELECT ann_review 
              FROM   review_table
              WHERE  employee_id = 2035)
 WHERE last_name = 'Bond';
